Clustered Index Scan
Short Description
Scan of a clustered index to return all rows
Detailed Description​
Scan of a clustered index to return all rows. If a WHERE clause is specified, only matching rows will be returned. If an ORDERED clause is specified, the rows will be returned in the sort order specified by the index, otherwise the rows will be returned in the most efficient way.
Additional Links​
- Microsoft Documentation - Showplan Logical and Physical Operators Reference
- Microsoft Documentation - Explain Plans
- Plansplaining - Hugo Kornelis' Blog series
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.